home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload Trio 2 / Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO / dir43 / qsrc_dsk.zip / MODEL / BUDGET2.QPR < prev    next >
Text File  |  1992-01-13  |  1KB  |  21 lines
  1. *       ╓─────────────────────────────────────────────────────────╖
  2. *       ║                                                         ║
  3. *       ║ BUDGET2.QPR                                             ║
  4. *       ║                                                         ║
  5. *       ╟─────────────────────────────────────────────────────────╢
  6. *       ║ Application Developed in _Using FoxPro 2_               ║
  7. *       ║                                                         ║
  8. *       ║ Lisa C. Slater and Steven E. Arnott                     ║
  9. *       ║                                                         ║
  10. *       ║ Copyright (c) 1991 Que Publishing                       ║
  11. *       ║                                                         ║
  12. *       ╙─────────────────────────────────────────────────────────╜
  13.  
  14.  
  15. SELECT PRODUCT.PRODNAME, BUDGET.PERIOD, SUM(BUDGET.BUDGETAMT);
  16.  FROM BUDGET, PRODUCT;
  17.  WHERE PRODUCT.PRODCODE = BUDGET.PRODCODE;
  18.  GROUP BY BUDGET.PRODCODE, BUDGET.PERIOD;
  19.  HAVING YEAR(BUDGET.PERIOD)=YEAR(M.PERIOD);
  20.  INTO CURSOR query2
  21.